<html>
<%@ page import="java.sql.*" %>
<center><img src="images/2.jpeg" border=0 width=363 height=228><img src="images/15.jpeg" border=0 width=263 height=228> <img src="images/7.jpeg" border=0 width=263 height=228>
<body bgcolor="#fdfec5" >
<%
try
{
int b=0;
String a=request.getParameter("a");
//String b=request.getParameter("b");
String c=request.getParameter("c");
String d=request.getParameter("d");
String e=request.getParameter("e");
String f=request.getParameter("f");
String g=request.getParameter("g");
String h=request.getParameter("h");
String i2=request.getParameter("i");
String j=request.getParameter("j");
String k=request.getParameter("k");
String l=request.getParameter("l");
String cat=request.getParameter("cat");
int i1=0;
  Class.forName("oracle.jdbc.driver.OracleDriver");
   Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","bank","bank");
  Statement st=con.createStatement();
  ResultSet rs=st.executeQuery("select count(accno) from customer");
  while(rs.next())
	{
	   b=rs.getInt(1)+1;
	  i1=2589+b;
	}
	
 int i=st.executeUpdate("insert into customer values('"+a+"',"+b+",'"+c+"','"+d+"','"+e+"','"+cat+"','"+f+"','"+g+"','"+h+"','"+i2+"','"+j+"','"+k+"','"+l+"',"+i1+")");
  int z=st.executeUpdate("insert into accountdetails values('"+b+"','"+d+"',5000,'"+c+"')");
 if(z>0)
 {
   System.out.println("inserted");%>
  <div  style="position:absolute; overflow:hidden; left:500px; top:350px; width:550px; height:20px; z-index:19">
<div class="wpmd">

</div></div>
<div style="font-size:20">
  Sucessfully Inserted<BR>
Your Pin NO:<%= i1 %><br>
Your Account no:<%= b %><br>
<a href="login.jsp">Click Here to  Login ...............</a>
</div>

   <%
 }
}
catch(Exception e){
e.printStackTrace();}
%>
</body>
</html>